package com.tiennt.android.callnotes.db;

public class DbUtils {
	public static final String DB_NAME = "NotesDB";
	public static final int DB_VERSION = 1;

	public static final String TB_NOTESDATA_NAME = "NotesData";
	public static final String TB_NOTESDATA_KEY_ROWID = "_id";
	public static final String TB_NOTESDATA_KEY_TITLE = "title";
	public static final String TB_NOTESDATA_KEY_CONTENT = "content";
	public static final String TB_NOTESDATA_KEY_CONTACTID = "contactid";
	public static final String TB_NOTESDATA_KEY_OUTGOING = "outgoing";
	public static final String TB_NOTESDATA_KEY_INCOMING = "incoming";

	public static final String QUERY_CREATE_TABLE_CONTENT = "create table if not exists  "
			+ TB_NOTESDATA_NAME
			+ " ( "
			+ TB_NOTESDATA_KEY_ROWID
			+ " integer primary key autoincrement, "
			+ TB_NOTESDATA_KEY_TITLE
			+ " text not null, "
			+ TB_NOTESDATA_KEY_CONTENT
			+ " text not null, "
			+ TB_NOTESDATA_KEY_CONTACTID
			+ " text not null, "
			+ TB_NOTESDATA_KEY_INCOMING
			+ " integer, "
			+ TB_NOTESDATA_KEY_OUTGOING
			+ " integer);";
}
